package com.mg.sms.dao;

public interface SMSConstant {

    public static final int DB_VERSION = 3;
    
    public static final String DB_NAME = "sms.db";
    
    public static final String TABLE_NAME = "SMS";
    
    public static final String DB_PATH = "/data/data/com.mg.sms/databases/";
    
    // SMS欄位
    public static final String SMS_ID            = "SMS_ID";
    public static final String SMS_FROM          = "SMS_FROM";
    public static final String SMS_BODY          = "SMS_BODY";
    public static final String SMS_STATUS        = "SMS_STATUS";
    public static final String SMS_SUBJECT       = "SMS_SUBJECT";
    public static final String SMS_TEL           = "SMS_TEL";
    public static final String SMS_ERROR_CODE    = "SMS_ERROR_CODE";
    public static final String SMS_RECEIVED_DATE = "SMS_RECEIVED_DATE";
    
    // 狀態
    public static final String STATUS_INCOMPLETE = "0";
    public static final String STATUS_COMPLETE   = "1";
    public static final String STATUS_FAIL       = "2";
    
    public static final String CREATE_SMS_TABLE = 
        "CREATE TABLE SMS(SMS_ID INTEGER PRIMARY KEY AUTOINCREMENT, SMS_FROM TEXT, SMS_BODY TEXT, SMS_SUBJECT TEXT, SMS_TEL TEXT,SMS_RECEIVED_DATE TEXT, SMS_STATUS TEXT, SMS_ERROR_CODE TEXT);";
}
